Loss-prevention teams see the risk but rarely hold the number. This worksheet converts an organization's profile into a defensible annual exposure figure — separating high-confidence recurring costs from low-probability tail risk — and shows what quality training plausibly offsets. Every line is traceable to its formula and source, and every assumption below is conservative by default and adjustable, so a finance reviewer can test it rather than dismiss it.
Defaults sit at or below the conservative end of published ranges, so the figure holds up under scrutiny. Move them to model your own case or to stress-test in front of a skeptic.
Expected serious (lost-time) incidents are estimated from sector-specific violence-injury rates per 10,000 full-time workers, drawn from the BLS Survey of Occupational Injuries and Illnesses — where health-care and social-assistance rates run roughly five times the private-industry average. The base case sums five high-confidence recurring costs: direct incident cost (workers' comp + medical, anchored to the average WC claim); post-incident productivity loss from trauma-related absenteeism and presenteeism (roughly one in five people exposed to a traumatic workplace event develop PTSD symptoms, carrying ~9.7 excess absence and ~33 presenteeism days each); attributable turnover (only the fraction of separations tied to an unsafe environment — nurses facing high violence are ~5× more likely to intend to leave, and replacing one RN averages $61,110); management and investigation time; and insurance pressure, since violence claims raise an employer's experience modification rate and workers'-comp premium for about three years, with claim frequency weighted more heavily than severity.
Customer/revenue loss and litigation/reputational exposure are held out of the base case as contingent tail risk, because their severity (a study of 486 retail mass-shooting incidents found ~18.7% revenue loss and 16.7% permanent closures; inadequate-security suits exceed $50M) is real but low-frequency — and folding severe-event magnitudes into a recurring figure is exactly what gets a business case dismissed. The American Hospital Association's finding that hospitals spend roughly four dollars remediating workplace violence for every one spent preventing it ($14.65B vs $3.62B) frames the whole exercise.
Compliance status is derived from your state and sector against the current mandate landscape: California's SB 553 (Labor Code 6401.9), effective July 1, 2024, reaches virtually all industries; roughly twenty states require health-care employers to maintain prevention plans and training; and New York's Retail Worker Safety Act took effect in 2026. Where a mandate applies, training is a legal requirement rather than a discretionary purchase — and insurers name safety training as the primary lever for reducing a debit EMR.
This worksheet is a decision-support estimate, not an actuarial certification or legal advice. Figures are directional and depend on the assumptions shown. Validate against your own incident, HR, and insurance data before presenting as authoritative.